DateFromTicks

Gets the formatted datetime string for the input ticks value.

String XFM.DateFromTicks(Int ticks, String dateFormat, Boolean useCurrentCulture)

XFM.DateFromTicks (633271869127973732,"dd/MON/yyyy HH:MI:SS",true)

Create a PBA containing the formatted ticks value in INSTALLDATE property:

EncloseInChar

Used in SQL statements to include a datetime string in single quotes.

String XFM.EncloseInChar (String stringToEnclose, String enclosingCharacter)

XFM.EncloseInChar("abc","'")to enclose the string "abc" in single quotes for a result of 'abc'

XFM.EncloseInChar(XFM.DateFromTicks([PropertyName|0],"MM/dd/yyyy",true),"'")

Round

Round off a value.

double XFM.Round (double value, Int digits)

XFM.Round(3.141592654, 2) results in 3.14